﻿CREATE TABLE [dbo].[CiException] (
    [Id]               INT            IDENTITY (1, 1) NOT NULL,
    [EventId]          NVARCHAR (50)  NULL,
    [Category]         NVARCHAR (50)  NULL,
    [Priority]         NVARCHAR (50)  NULL,
    [Severity]         NVARCHAR (50)  NULL,
    [Title]            NVARCHAR (200) NULL,
    [Timestamp]        DATETIME       NULL,
    [MachineName]      NVARCHAR (200) NULL,
    [AppDomainName]    NVARCHAR (100) NULL,
    [ProcessId]        NVARCHAR (100) NULL,
    [ProcessName]      NVARCHAR (200) NULL,
    [ThreadName]       NVARCHAR (200) NULL,
    [Win32ThreadId]    NVARCHAR (200) NULL,
    [Message]          NVARCHAR (MAX) NULL,
    [FormattedMessage] NVARCHAR (MAX) NULL,
    [CreateOn]         DATETIME       DEFAULT (getdate()) NULL,
    [CreateUserId]     NVARCHAR (50)  NULL,
    [CreateBy]         NVARCHAR (50)  NULL,
    CONSTRAINT [PK_CIEXCEPTION] PRIMARY KEY NONCLUSTERED ([Id] ASC)
);

